<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xml:lang="en" lang="en" xmlns="http://www.w3.org/1999/xhtml">
  <head>
    <meta http-equiv="Content-Type" content="text/html;charset=utf-8" />
    <meta http-equiv="Content-Style-Type" content="text/css" />
    <!-- MOTW-DISABLED saved from url=(0014)about:internet -->
    <title>How to update a filter condition dynamically when the report runs</title>
    <link rel="StyleSheet" href="css/parameter.css" type="text/css" media="all" />
    <link rel="StyleSheet" href="css/webworks.css" type="text/css" media="all" />
    <link rel="StyleSheet" href="webworks.css" type="text/css" media="all" />
    <script type="text/javascript" language="JavaScript1.2">
      <!--
        var  WebWorksRootPath = "";
      // -->
    </script>
  </head>
  <body>
    <div style="text-align: left;">
      <table cellspacing="0" summary="">
        <tr>
          <td>
            <a href="rp-HowToDefineADataSetParameter.html"><img src="images/prev.gif" alt="Previous" border="0" /></a>
          </td>
          <td>
            <a href="sub-BuildingARptThatContainsSubreportsIntro.html"><img src="images/next.gif" alt="Next" border="0" /></a>
          </td>
        </tr>
      </table>
    </div>
    <hr align="left" />
    <blockquote>
      <h4 class="N_hth_HowToHelp"><a name="170692">How to update a filter condition dynamically when the report runs</a></h4>
      <p class="b_Body"><a name="170742">This procedure assumes that you already created a report design that contains a table or list to display data from a data set and uses one or more report parameters. This procedure uses the parameter to filter the values that the table displays.</a></p>
      <div class="N_n1_NumList1_outer" style="margin-left: 0pt">
        <table border="0" cellspacing="0" cellpadding="0" summary="" role="presentation">
          <tr style="vertical-align: baseline">
            <td>
              <div class="N_n1_NumList1_inner" style="width: 14.1732pt; white-space: nowrap">
                <span class="zAuto_0023Format">1&nbsp;&nbsp;</span>
              </div>
            </td>
            <td width="100%">
              <div class="N_n1_NumList1_inner"><a name="170696">In the layout editor, select the table element or list element to filter. </a></div>
            </td>
          </tr>
        </table>
      </div>
      <div class="N_n1_NumList1_outer" style="margin-left: 0pt">
        <table border="0" cellspacing="0" cellpadding="0" summary="" role="presentation">
          <tr style="vertical-align: baseline">
            <td>
              <div class="N_n1_NumList1_inner" style="width: 14.1732pt; white-space: nowrap">
                <span class="zAuto_0023Format">2&nbsp;&nbsp;</span>
              </div>
            </td>
            <td width="100%">
              <div class="N_n1_NumList1_inner"><a name="170701">In Property Editor, choose the Filters tab.</a></div>
            </td>
          </tr>
        </table>
      </div>
      <div class="N_n1_NumList1_outer" style="margin-left: 0pt">
        <table border="0" cellspacing="0" cellpadding="0" summary="" role="presentation">
          <tr style="vertical-align: baseline">
            <td>
              <div class="N_n1_NumList1_inner" style="width: 14.1732pt; white-space: nowrap">
                <span class="zAuto_0023Format">3&nbsp;&nbsp;</span>
              </div>
            </td>
            <td width="100%">
              <div class="N_n1_NumList1_inner"><a name="170706">Choose Add to create a new filter condition.</a></div>
            </td>
          </tr>
        </table>
      </div>
      <div class="N_n1_NumList1_outer" style="margin-left: 0pt">
        <table border="0" cellspacing="0" cellpadding="0" summary="" role="presentation">
          <tr style="vertical-align: baseline">
            <td>
              <div class="N_n1_NumList1_inner" style="width: 14.1732pt; white-space: nowrap">
                <span class="zAuto_0023Format">4&nbsp;&nbsp;</span>
              </div>
            </td>
            <td width="100%">
              <div class="N_n1_NumList1_inner"><a name="170710">In New Filter Condition, specify the filter condition.</a></div>
            </td>
          </tr>
        </table>
      </div>
      <div class="N_n2_NumList2_outer" style="margin-left: 14.1732pt">
        <table border="0" cellspacing="0" cellpadding="0" summary="" role="presentation">
          <tr style="vertical-align: baseline">
            <td>
              <div class="N_n2_NumList2_inner" style="width: 14.1732pt; white-space: nowrap">
                <span class="zAuto_0023FormatGray">1&nbsp;&nbsp;</span>
              </div>
            </td>
            <td width="100%">
              <div class="N_n2_NumList2_inner"><a name="170720">In the first field, select a field from the drop-down list. Alternatively, open the expression builder to create a more complex expression.</a></div>
            </td>
          </tr>
        </table>
      </div>
      <div class="N_n2_NumList2_outer" style="margin-left: 14.1732pt">
        <table border="0" cellspacing="0" cellpadding="0" summary="" role="presentation">
          <tr style="vertical-align: baseline">
            <td>
              <div class="N_n2_NumList2_inner" style="width: 14.1732pt; white-space: nowrap">
                <span class="zAuto_0023FormatGray">2&nbsp;&nbsp;</span>
              </div>
            </td>
            <td width="100%">
              <div class="N_n2_NumList2_inner"><a name="299244">In the second field, select an operator from the drop-down list.</a></div>
            </td>
          </tr>
        </table>
      </div>
      <div class="N_n2_NumList2_outer" style="margin-left: 14.1732pt">
        <table border="0" cellspacing="0" cellpadding="0" summary="" role="presentation">
          <tr style="vertical-align: baseline">
            <td>
              <div class="N_n2_NumList2_inner" style="width: 14.1732pt; white-space: nowrap">
                <span class="zAuto_0023FormatGray">3&nbsp;&nbsp;</span>
              </div>
            </td>
            <td width="100%">
              <div class="N_n2_NumList2_inner"><a name="170721">In the third field, specify the name of the report parameter that you created. You can use the expression builder to select the report parameter from the list of report parameters in the report design, as shown in </a><a href="#299387" title="How to update a filter condition dynamically when the report runs">Figure&nbsp;11-5</a>.</div>
            </td>
          </tr>
        </table>
      </div>
      <p class="i3_Image3"><a name="299296"><img class="Default" src="images/expbuilder_rp.png" style="display: inline; float: none; left: 0.0; top: 0.0" alt="Figure 11-5 Using the expression builder to select a report parameter" /></a></p>
      <div class="fc3_FigCall3Title">
        <b class="Bold">Figure&nbsp;11-5&nbsp;&nbsp;</b><a name="299387">Using the expression builder to select a report parameter</a></div>
      <div class="N_i2_Indent2"><a name="299388">Choose OK to apply the expression to the filter condition. New Filter Condition displays the completed filter condition, as shown in </a><a href="#299359" title="How to update a filter condition dynamically when the report runs">Figure&nbsp;11-6</a>.</div>
      <p class="i3_Image3"><a name="299343"><img class="Default" src="images/tablefilterwithparam.png" style="display: inline; float: none; left: 0.0; top: 0.0" alt="Figure 11-6 A filter condition" /></a></p>
      <div class="fc3_FigCall3Title">
        <b class="Bold">Figure&nbsp;11-6&nbsp;&nbsp;</b><a name="299359">A filter condition</a></div>
      <div class="N_n2_NumList2_outer" style="margin-left: 14.1732pt">
        <table border="0" cellspacing="0" cellpadding="0" summary="" role="presentation">
          <tr style="vertical-align: baseline">
            <td>
              <div class="N_n2_NumList2_inner" style="width: 14.1732pt; white-space: nowrap">
                <span class="zAuto_0023FormatGray">4&nbsp;&nbsp;</span>
              </div>
            </td>
            <td width="100%">
              <div class="N_n2_NumList2_inner"><a name="299364">Choose OK to save the filter condition.</a></div>
            </td>
          </tr>
        </table>
      </div>
      <div class="N_i2_Indent2"><a name="332567">The filter condition appears on the Filters page in Property Editor, as shown in </a><a href="#332576" title="How to update a filter condition dynamically when the report runs">Figure&nbsp;11-7</a>.</div>
      <p class="i3_Image3"><a name="332574"><img class="Default" src="images/filter_with_reportparam.png" style="display: inline; float: none; left: 0.0; top: 0.0" alt="Figure 11-7 Filter condition set to a report parameter" /></a></p>
      <div class="fc3_FigCall3Title">
        <b class="Bold">Figure&nbsp;11-7&nbsp;&nbsp;</b><a name="332576">Filter condition set to a report parameter</a></div>
      <div class="N_n1_NumList1_outer" style="margin-left: 0pt">
        <table border="0" cellspacing="0" cellpadding="0" summary="" role="presentation">
          <tr style="vertical-align: baseline">
            <td>
              <div class="N_n1_NumList1_inner" style="width: 14.1732pt; white-space: nowrap">
                <span class="zAuto_0023Format">5&nbsp;&nbsp;</span>
              </div>
            </td>
            <td width="100%">
              <div class="N_n1_NumList1_inner"><a name="170738">Preview the report.</a></div>
            </td>
          </tr>
        </table>
      </div>
      <div class="N_i_Indent1"><a name="170749">Enter Parameters appears and displays the report parameters that you created. </a><a href="#441814" title="How to update a filter condition dynamically when the report runs">Figure&nbsp;11-8</a> shows an example.</div>
      <p class="i2_Image2"><a name="170765"><img class="Default" src="images/enter_param_example.png" style="display: inline; float: none; left: 0.0; top: 0.0" alt="Figure 11-8 Enter Parameters showing a report parameter" /></a></p>
      <div class="fc2_FigCall2Title">
        <b class="Bold">Figure&nbsp;11-8&nbsp;&nbsp;</b><a name="441814">Enter Parameters showing a report parameter</a></div>
      <div class="N_n1_NumList1_outer" style="margin-left: 0pt">
        <table border="0" cellspacing="0" cellpadding="0" summary="" role="presentation">
          <tr style="vertical-align: baseline">
            <td>
              <div class="N_n1_NumList1_inner" style="width: 14.1732pt; white-space: nowrap">
                <span class="zAuto_0023Format">6&nbsp;&nbsp;</span>
              </div>
            </td>
            <td width="100%">
              <div class="N_n1_NumList1_inner"><a name="473468">Specify values for the report parameters, then choose OK.</a></div>
            </td>
          </tr>
        </table>
      </div>
      <div class="N_i_Indent1"><a name="473469">The report displays data that matches the values that you specified.</a></div>
      <p class="b_Body"><a name="299569"> &nbsp;</a></p>
    </blockquote>
    <hr align="left" />
    <table align="right" summary="">
      <tr>
        <td class="WebWorks_Company_Name_Bottom">
          <a href="notices.html">(c) Copyright Actuate Corporation 2013</a>
        </td>
      </tr>
    </table>
  </body>
</html>